package com.mv.dao;

import com.mv.entity.Actor;
import com.mv.entity.Type;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

/**
 * @author Administrator
 */
@Repository
public interface ActorMapper extends Mapper<Actor> {



    /**
     * 根据电影编号查询演员集合
     * 程龙
     * @param movieId
     * @return
     */
    @Select("SELECT a.id,a.actorName,a.sex,a.headImg FROM actor a INNER JOIN actor_movie am ON a.id = am.actorId WHERE am.movieId = #{movieId}")
    List<Actor> selectActorForMovieVo(@Param("movieId")Integer movieId);




}